/*
Purpose: median household income from CPS among families with children
*/
 
use "data/raw/cps_00004.dta", clear
 
keep if nchild>=1&nchild<=9

collapse (p50) hhincome [aw=asecwth],by(year statefip)

save "data/clean/medhhinc_by_state_80_23", replace
